﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

using LY.Entity;
using LY.Entity.PageSearch;
using LY.Entity.SearchEntity;
namespace LY.DataAccess.Repository
{
  public class SiteconfigRepository:BaseRepository
    {
      //添加系统设置信息
      ////public long SaveSiteconfig(S_Siteconfig sc) {
      ////    return base.Insert(sc);
      ////}
        //根据ID获取网站配置信息
      public S_Siteconfig getSiteconfig() {
          string sql = @"SELECT [Webname]
                          ,[Weburl]
                          ,[Weblogo]
                          ,[Webcompany]
                          ,[Webaddress]
                          ,[Webtel]
                          ,[Webfax]
                          ,[Webmail]
                          ,[Webcrod]
                          ,[Webtitle]
                          ,[Webkeyword]
                          ,[Webdescription]
                          ,[Webcopyright]
                          ,[Webpath]
                          ,[Webmanagepath]
                          ,[Staticstatus]
                          ,[Staticextension]
                          ,[Memberstatus]
                          ,[Commentstatus]
                          ,[Logstatus]
                          ,[Webstatus]
                          ,[Webclosereason]
                          ,[Webcountcode]
                          ,[Smsapiurl]
                          ,[Smsusername]
                          ,[Smspassword]
                          ,[Emailsmtp]
                          ,[Emailport]
                          ,[Emailfrom]
                          ,[Emailusername]
                          ,[Emailpassword]
                          ,[Emailnickname]
                          ,[Filepath]
                          ,[Filesave]
                          ,[Fileextension]
                          ,[Attachsize]
                          ,[Imgsize]
                          ,[Imgmaxheight]
                          ,[Imgmaxwidth]
                          ,[Thumbnailheight]
                          ,[Thumbnailwidth]
                          ,[Watermarktype]
                          ,[Watermarkposition]
                          ,[Watermarkimgquality]
                          ,[Watermarkpic]
                          ,[Watermarktransparency]
                          ,[Watermarktext]
                          ,[Watermarkfont]
                          ,[Watermarkfontsize]
                          ,[Id]
                          FROM  [S_Siteconfig]";
          return base.Get<S_Siteconfig>(sql,null);
      }
    }
}
